Dataset statistics
| Number of variables | 44 |
|---|---|
| Number of observations | 530 |
| Missing cells | 8371 |
| Missing cells (%) | 35.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 182.3 KiB |
| Average record size in memory | 352.2 B |
Variable types
| CAT | 19 |
|---|---|
| NUM | 15 |
| UNSUPPORTED | 4 |
| DATE | 4 |
| BOOL | 2 |
Select project has constant value "530" | Constant |
FR1_ProjectName has constant value "530" | Constant |
Asset ID: has a high cardinality: 522 distinct values | High cardinality |
Asset Description has a high cardinality: 527 distinct values | High cardinality |
Comments has a high cardinality: 177 distinct values | High cardinality |
longitude is highly correlated with Bund length (m) | High correlation |
Bund length (m) is highly correlated with longitude | High correlation |
Other Wood Species is highly correlated with Land Drainage Consent Difficulty and 1 other fields | High correlation |
Land Drainage Consent Difficulty is highly correlated with Other Wood Species | High correlation |
Ecological Consent Difficulty is highly correlated with Other Wood Species | High correlation |
Watercourse Type has 23 (4.3%) missing values | Missing |
Stream Width (m) has 88 (16.6%) missing values | Missing |
Land Drainage Consent Difficulty has 35 (6.6%) missing values | Missing |
Ecological Consent Difficulty has 48 (9.1%) missing values | Missing |
Average member length in Leaky Barrier (m) has 88 (16.6%) missing values | Missing |
Wood Diameter (cm) has 174 (32.8%) missing values | Missing |
Height of Leaky Barrier above bed (cm) has 104 (19.6%) missing values | Missing |
Height of Leaky Barrier above bank (cm) has 281 (53.0%) missing values | Missing |
Wood Species Used has 415 (78.3%) missing values | Missing |
Other Wood Species has 466 (87.9%) missing values | Missing |
Bund height (m) has 521 (98.3%) missing values | Missing |
Bund width (m) has 521 (98.3%) missing values | Missing |
Bund length (m) has 521 (98.3%) missing values | Missing |
Bund Material has 516 (97.4%) missing values | Missing |
Gully Block Length (m) has 530 (100.0%) missing values | Missing |
Gully Block Width (m) has 530 (100.0%) missing values | Missing |
Gully Block Material has 530 (100.0%) missing values | Missing |
Soil Equipment or Technique Used has 530 (100.0%) missing values | Missing |
Flood Efficacy has 102 (19.2%) missing values | Missing |
FR3_AreaRough has 518 (97.7%) missing values | Missing |
Storage Created (m3) has 8 (1.5%) missing values | Missing |
FR3_AreaIncreasedLoss has 523 (98.7%) missing values | Missing |
Changed Flood Pathway? has 138 (26.0%) missing values | Missing |
Reduced Erosion? has 381 (71.9%) missing values | Missing |
Asset Condition has 33 (6.2%) missing values | Missing |
Date Assessed has 32 (6.0%) missing values | Missing |
Comments has 211 (39.8%) missing values | Missing |
Creator has 491 (92.6%) missing values | Missing |
Editor has 12 (2.3%) missing values | Missing |
Asset ID: is uniformly distributed | Uniform |
Asset Description is uniformly distributed | Uniform |
ObjectID has unique values | Unique |
GlobalID has unique values | Unique |
CreationDate has unique values | Unique |
Gully Block Length (m) is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Gully Block Width (m) is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Gully Block Material is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Soil Equipment or Technique Used is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Installed Cost (£) has 9 (1.7%) zeros | Zeros |
Height of Leaky Barrier above bank (cm) has 160 (30.2%) zeros | Zeros |
Reproduction
| Analysis started | 2020-10-26 09:41:20.406291 |
|---|---|
| Analysis finished | 2020-10-26 09:43:15.217821 |
| Duration | 1 minute and 54.81 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 530 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 686.4320755 |
|---|---|
| Minimum | 42 |
| Maximum | 1254 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 42 |
|---|---|
| 5-th percentile | 175.9 |
| Q1 | 390.5 |
| median | 684.5 |
| Q3 | 965.75 |
| 95-th percentile | 1187.55 |
| Maximum | 1254 |
| Range | 1212 |
| Interquartile range (IQR) | 575.25 |
Descriptive statistics
| Standard deviation | 317.9346631 |
|---|---|
| Coefficient of variation (CV) | 0.4631698816 |
| Kurtosis | -1.013738266 |
| Mean | 686.4320755 |
| Median Absolute Deviation (MAD) | 287.5 |
| Skewness | -0.02965033573 |
| Sum | 363809 |
| Variance | 101082.45 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1014 | 1 | 0.2% | |
| 343 | 1 | 0.2% | |
| 326 | 1 | 0.2% | |
| 327 | 1 | 0.2% | |
| 328 | 1 | 0.2% | |
| 329 | 1 | 0.2% | |
| 330 | 1 | 0.2% | |
| 331 | 1 | 0.2% | |
| 332 | 1 | 0.2% | |
| 334 | 1 | 0.2% | |
| Other values (520) | 520 | 98.1% |
| Value | Count | Frequency (%) | |
| 42 | 1 | 0.2% | |
| 45 | 1 | 0.2% | |
| 47 | 1 | 0.2% | |
| 48 | 1 | 0.2% | |
| 56 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 1254 | 1 | 0.2% | |
| 1253 | 1 | 0.2% | |
| 1252 | 1 | 0.2% | |
| 1251 | 1 | 0.2% | |
| 1250 | 1 | 0.2% |
| Distinct | 530 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 KiB |
| 856a0a2c-4536-44fb-a048-bed5bf74a53f | 1 |
|---|---|
| bbc3e93a-da63-4ae9-a5f4-f0145999d070 | 1 |
| 088c785e-adb1-4307-9321-b9554afcf9be | 1 |
| 0153cc58-adb6-4ad5-bbc5-77808d535f10 | 1 |
| 97126ee9-c3a0-4af7-9e4b-a5eb0220d29f | 1 |
| Other values (525) |
| Value | Count | Frequency (%) | |
| 856a0a2c-4536-44fb-a048-bed5bf74a53f | 1 | 0.2% | |
| bbc3e93a-da63-4ae9-a5f4-f0145999d070 | 1 | 0.2% | |
| 088c785e-adb1-4307-9321-b9554afcf9be | 1 | 0.2% | |
| 0153cc58-adb6-4ad5-bbc5-77808d535f10 | 1 | 0.2% | |
| 97126ee9-c3a0-4af7-9e4b-a5eb0220d29f | 1 | 0.2% | |
| 1e6995d7-d01d-4f77-9ac2-dd6c91ca2d79 | 1 | 0.2% | |
| 5cbd2645-3c34-4487-8260-05a53865556c | 1 | 0.2% | |
| 90e03d9a-e6d5-4679-aa58-2eb5e2231cc4 | 1 | 0.2% | |
| 8906a1e8-9ce5-487a-b86f-951f060bcefa | 1 | 0.2% | |
| 6fedb86c-65ad-4fdf-82d7-7c6fa95f6152 | 1 | 0.2% | |
| Other values (520) | 520 | 98.1% |
Unique
| Unique | 530 ? |
|---|---|
| Unique (%) | 100.0% |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 KiB |
| A017 |
|---|
| Value | Count | Frequency (%) | |
| A017 | 530 | 100.0% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 KiB |
| Shipston |
|---|
| Value | Count | Frequency (%) | |
| Shipston | 530 | 100.0% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
| Distinct | 522 |
|---|---|
| Distinct (%) | 98.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 KiB |
| A017_2007021345 | 2 |
|---|---|
| A017_2006151131 | 2 |
| A017_2006011141 | 2 |
| A017_2005041404 | 2 |
| A017_2004271037 | 2 |
| Other values (517) |
| Value | Count | Frequency (%) | |
| A017_2007021345 | 2 | 0.4% | |
| A017_2006151131 | 2 | 0.4% | |
| A017_2006011141 | 2 | 0.4% | |
| A017_2005041404 | 2 | 0.4% | |
| A017_2004271037 | 2 | 0.4% | |
| A017_2003021344 | 2 | 0.4% | |
| A017_2002131359 | 2 | 0.4% | |
| A017_2007021343 | 2 | 0.4% | |
| A017_1911091444 | 1 | 0.2% | |
| A017_2004271221 | 1 | 0.2% | |
| Other values (512) | 512 | 96.6% |
Unique
| Unique | 514 ? |
|---|---|
| Unique (%) | 97.0% |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Asset Type
Categorical
| Distinct | 9 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 KiB |
| leaky_barriers | |
|---|---|
| offline_storage_areas | 36 |
| runoff_pathway_management | 14 |
| cross_slope_woodland_creation | 2 |
| riparian_woodland_creation | 2 |
| Other values (4) | 5 |
| Value | Count | Frequency (%) | |
| leaky_barriers | 471 | 88.9% | |
| offline_storage_areas | 36 | 6.8% | |
| runoff_pathway_management | 14 | 2.6% | |
| cross_slope_woodland_creation | 2 | 0.4% | |
| riparian_woodland_creation | 2 | 0.4% | |
| floodplain_wetland_restoration | 2 | 0.4% | |
| river_restoration | 1 | 0.2% | |
| soil_and_land_management | 1 | 0.2% | |
| floodplain_woodland_creation | 1 | 0.2% |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | 0.6% |
Length
| Max length | 30 |
|---|---|
| Median length | 14 |
| Mean length | 14.97924528 |
| Min length | 14 |
| Distinct | 527 |
|---|---|
| Distinct (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 KiB |
| DELETE | 4 |
|---|---|
| KNEELONG05LB5 | 1 |
| SUTT5 | 1 |
| CAMNP05LB2 | 1 |
| CAMCH15LB12 | 1 |
| Other values (522) |
| Value | Count | Frequency (%) | |
| DELETE | 4 | 0.8% | |
| KNEELONG05LB5 | 1 | 0.2% | |
| SUTT5 | 1 | 0.2% | |
| CAMNP05LB2 | 1 | 0.2% | |
| CAMCH15LB12 | 1 | 0.2% | |
| KNEEBEECH02LB1 | 1 | 0.2% | |
| SUTTJERV15LB15 | 1 | 0.2% | |
| STOURCOW09LB9 | 1 | 0.2% | |
| SUTT2 | 1 | 0.2% | |
| NETHWALT07 | 1 | 0.2% | |
| Other values (517) | 517 | 97.5% |
Unique
| Unique | 526 ? |
|---|---|
| Unique (%) | 99.2% |
Length
| Max length | 28 |
|---|---|
| Median length | 13 |
| Mean length | 12.5754717 |
| Min length | 1 |
Date Installed
Date
| Distinct | 114 |
|---|---|
| Distinct (%) | 21.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 KiB |
| Minimum | 2017-05-31 12:00:00 |
|---|---|
| Maximum | 2020-10-07 11:00:00 |
| Distinct | 38 |
|---|---|
| Distinct (%) | 7.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 198.4509434 |
|---|---|
| Minimum | 0 |
| Maximum | 6000 |
| Zeros | 9 |
| Zeros (%) | 1.7% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 100 |
| Q3 | 150 |
| 95-th percentile | 687.5 |
| Maximum | 6000 |
| Range | 6000 |
| Interquartile range (IQR) | 148 |
Descriptive statistics
| Standard deviation | 535.6539688 |
|---|---|
| Coefficient of variation (CV) | 2.699175724 |
| Kurtosis | 52.00653745 |
| Mean | 198.4509434 |
| Median Absolute Deviation (MAD) | 50 |
| Skewness | 6.613252697 |
| Sum | 105179 |
| Variance | 286925.1743 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 150 | 119 | 22.5% | |
| 100 | 115 | 21.7% | |
| 1 | 102 | 19.2% | |
| 2 | 34 | 6.4% | |
| 120 | 28 | 5.3% | |
| 90 | 23 | 4.3% | |
| 126 | 15 | 2.8% | |
| 180 | 14 | 2.6% | |
| 60 | 10 | 1.9% | |
| 230 | 9 | 1.7% | |
| Other values (28) | 61 | 11.5% |
| Value | Count | Frequency (%) | |
| 0 | 9 | 1.7% | |
| 1 | 102 | 19.2% | |
| 2 | 34 | 6.4% | |
| 19 | 1 | 0.2% | |
| 60 | 10 | 1.9% |
| Value | Count | Frequency (%) | |
| 6000 | 1 | 0.2% | |
| 4900 | 1 | 0.2% | |
| 4080 | 1 | 0.2% | |
| 4000 | 1 | 0.2% | |
| 3800 | 1 | 0.2% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 23 |
| Missing (%) | 4.3% |
| Memory size | 4.1 KiB |
| ordinary | |
|---|---|
| coast | 1 |
| Value | Count | Frequency (%) | |
| ordinary | 506 | 95.5% | |
| coast | 1 | 0.2% | |
| (Missing) | 23 | 4.3% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.2% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.777358491 |
| Min length | 3 |
| Distinct | 23 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 88 |
| Missing (%) | 16.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.799773756 |
|---|---|
| Minimum | 0.4 |
| Maximum | 38 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 0.4 |
|---|---|
| 5-th percentile | 0.505 |
| Q1 | 1 |
| median | 1.5 |
| Q3 | 2 |
| 95-th percentile | 2.485 |
| Maximum | 38 |
| Range | 37.6 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 3.185874427 |
|---|---|
| Coefficient of variation (CV) | 1.77015273 |
| Kurtosis | 67.35301518 |
| Mean | 1.799773756 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 7.878663072 |
| Sum | 795.5 |
| Variance | 10.14979587 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 173 | 32.6% | |
| 2 | 108 | 20.4% | |
| 1.5 | 90 | 17.0% | |
| 0.5 | 22 | 4.2% | |
| 3 | 11 | 2.1% | |
| 0.75 | 10 | 1.9% | |
| 1.25 | 5 | 0.9% | |
| 1.2 | 3 | 0.6% | |
| 0.6 | 3 | 0.6% | |
| 2.5 | 3 | 0.6% | |
| Other values (13) | 14 | 2.6% | |
| (Missing) | 88 | 16.6% |
| Value | Count | Frequency (%) | |
| 0.4 | 1 | 0.2% | |
| 0.5 | 22 | 4.2% | |
| 0.6 | 3 | 0.6% | |
| 0.7 | 1 | 0.2% | |
| 0.75 | 10 | 1.9% |
| Value | Count | Frequency (%) | |
| 38 | 1 | 0.2% | |
| 26 | 1 | 0.2% | |
| 25 | 2 | 0.4% | |
| 24 | 1 | 0.2% | |
| 23 | 1 | 0.2% |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 35 |
| Missing (%) | 6.6% |
| Memory size | 4.1 KiB |
| easy | |
|---|---|
| moderate | 21 |
| n_a | 21 |
| Value | Count | Frequency (%) | |
| easy | 453 | 85.5% | |
| moderate | 21 | 4.0% | |
| n_a | 21 | 4.0% | |
| (Missing) | 35 | 6.6% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 8 |
|---|---|
| Median length | 4 |
| Mean length | 4.052830189 |
| Min length | 3 |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 48 |
| Missing (%) | 9.1% |
| Memory size | 4.1 KiB |
| n_a | |
|---|---|
| easy | |
| moderate | 2 |
| Value | Count | Frequency (%) | |
| n_a | 409 | 77.2% | |
| easy | 71 | 13.4% | |
| moderate | 2 | 0.4% | |
| (Missing) | 48 | 9.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 8 |
|---|---|
| Median length | 3 |
| Mean length | 3.152830189 |
| Min length | 3 |
| Distinct | 19 |
|---|---|
| Distinct (%) | 4.3% |
| Missing | 88 |
| Missing (%) | 16.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.730769231 |
|---|---|
| Minimum | 1 |
| Maximum | 30 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2.5 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 30 |
| Range | 29 |
| Interquartile range (IQR) | 1.5 |
Descriptive statistics
| Standard deviation | 2.365407128 |
|---|---|
| Coefficient of variation (CV) | 0.6340266528 |
| Kurtosis | 50.31163294 |
| Mean | 3.730769231 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 5.575694865 |
| Sum | 1649 |
| Variance | 5.595150881 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 3 | 116 | 21.9% | |
| 2 | 67 | 12.6% | |
| 2.5 | 65 | 12.3% | |
| 4 | 57 | 10.8% | |
| 6 | 48 | 9.1% | |
| 5 | 37 | 7.0% | |
| 3.5 | 18 | 3.4% | |
| 1.5 | 11 | 2.1% | |
| 8 | 7 | 1.3% | |
| 7 | 4 | 0.8% | |
| Other values (9) | 12 | 2.3% | |
| (Missing) | 88 | 16.6% |
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.2% | |
| 1.5 | 11 | 2.1% | |
| 2 | 67 | 12.6% | |
| 2.5 | 65 | 12.3% | |
| 3 | 116 | 21.9% |
| Value | Count | Frequency (%) | |
| 30 | 1 | 0.2% | |
| 25 | 1 | 0.2% | |
| 15 | 2 | 0.4% | |
| 12 | 1 | 0.2% | |
| 10 | 2 | 0.4% |
| Distinct | 22 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 174 |
| Missing (%) | 32.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.02879213 |
|---|---|
| Minimum | 1 |
| Maximum | 3015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 15 |
| median | 20 |
| Q3 | 25 |
| 95-th percentile | 45 |
| Maximum | 3015 |
| Range | 3014 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 206.6780566 |
|---|---|
| Coefficient of variation (CV) | 5.037390715 |
| Kurtosis | 152.0031941 |
| Mean | 41.02879213 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 12.00192965 |
| Sum | 14606.25 |
| Variance | 42715.81906 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 15 | 95 | 17.9% | |
| 20 | 79 | 14.9% | |
| 25 | 78 | 14.7% | |
| 30 | 45 | 8.5% | |
| 10 | 21 | 4.0% | |
| 45 | 6 | 1.1% | |
| 35 | 5 | 0.9% | |
| 50 | 5 | 0.9% | |
| 40 | 3 | 0.6% | |
| 100 | 3 | 0.6% | |
| Other values (12) | 16 | 3.0% | |
| (Missing) | 174 | 32.8% |
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.2% | |
| 2.25 | 1 | 0.2% | |
| 4 | 1 | 0.2% | |
| 7.5 | 2 | 0.4% | |
| 10 | 21 | 4.0% |
| Value | Count | Frequency (%) | |
| 3015 | 1 | 0.2% | |
| 2040 | 1 | 0.2% | |
| 1501 | 1 | 0.2% | |
| 200 | 1 | 0.2% | |
| 100 | 3 | 0.6% |
| Distinct | 21 |
|---|---|
| Distinct (%) | 4.9% |
| Missing | 104 |
| Missing (%) | 19.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.83920188 |
|---|---|
| Minimum | 0 |
| Maximum | 730 |
| Zeros | 5 |
| Zeros (%) | 0.9% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 15 |
| median | 20 |
| Q3 | 30 |
| 95-th percentile | 50 |
| Maximum | 730 |
| Range | 730 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 39.25694349 |
|---|---|
| Coefficient of variation (CV) | 1.519278485 |
| Kurtosis | 245.8067708 |
| Mean | 25.83920188 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 14.14126967 |
| Sum | 11007.5 |
| Variance | 1541.107613 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 15 | 125 | 23.6% | |
| 20 | 74 | 14.0% | |
| 25 | 56 | 10.6% | |
| 30 | 56 | 10.6% | |
| 10 | 34 | 6.4% | |
| 40 | 16 | 3.0% | |
| 45 | 15 | 2.8% | |
| 60 | 10 | 1.9% | |
| 35 | 6 | 1.1% | |
| 0 | 5 | 0.9% | |
| Other values (11) | 29 | 5.5% | |
| (Missing) | 104 | 19.6% |
| Value | Count | Frequency (%) | |
| 0 | 5 | 0.9% | |
| 1 | 4 | 0.8% | |
| 1.5 | 2 | 0.4% | |
| 5 | 4 | 0.8% | |
| 7 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 730 | 1 | 0.2% | |
| 200 | 1 | 0.2% | |
| 150 | 3 | 0.6% | |
| 100 | 4 | 0.8% | |
| 60 | 10 | 1.9% |
| Distinct | 22 |
|---|---|
| Distinct (%) | 8.8% |
| Missing | 281 |
| Missing (%) | 53.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 79.46646586 |
|---|---|
| Minimum | 0 |
| Maximum | 15200 |
| Zeros | 160 |
| Zeros (%) | 30.2% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 20 |
| 95-th percentile | 100 |
| Maximum | 15200 |
| Range | 15200 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 964.7526256 |
|---|---|
| Coefficient of variation (CV) | 12.14037412 |
| Kurtosis | 246.2319994 |
| Mean | 79.46646586 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 15.65335713 |
| Sum | 19787.15 |
| Variance | 930747.6287 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 160 | 30.2% | |
| 15 | 15 | 2.8% | |
| 20 | 13 | 2.5% | |
| 30 | 11 | 2.1% | |
| 50 | 11 | 2.1% | |
| 100 | 9 | 1.7% | |
| 10 | 6 | 1.1% | |
| 60 | 4 | 0.8% | |
| 75 | 3 | 0.6% | |
| 25 | 3 | 0.6% | |
| Other values (12) | 14 | 2.6% | |
| (Missing) | 281 | 53.0% |
| Value | Count | Frequency (%) | |
| 0 | 160 | 30.2% | |
| 0.2 | 1 | 0.2% | |
| 0.25 | 1 | 0.2% | |
| 0.5 | 1 | 0.2% | |
| 1.2 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 15200 | 1 | 0.2% | |
| 1050 | 1 | 0.2% | |
| 200 | 1 | 0.2% | |
| 150 | 1 | 0.2% | |
| 110 | 1 | 0.2% |
| Distinct | 6 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 415 |
| Missing (%) | 78.3% |
| Memory size | 4.1 KiB |
| other | |
|---|---|
| willow_live | |
| willow_dead | |
| ash | |
| beech | 1 |
| Value | Count | Frequency (%) | |
| other | 56 | 10.6% | |
| willow_live | 26 | 4.9% | |
| willow_dead | 25 | 4.7% | |
| ash | 6 | 1.1% | |
| beech | 1 | 0.2% | |
| softwood | 1 | 0.2% | |
| (Missing) | 415 | 78.3% |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 1.7% |
Length
| Max length | 11 |
|---|---|
| Median length | 3 |
| Mean length | 3.994339623 |
| Min length | 3 |
| Distinct | 5 |
|---|---|
| Distinct (%) | 7.8% |
| Missing | 466 |
| Missing (%) | 87.9% |
| Memory size | 4.1 KiB |
| Machined | |
|---|---|
| Leylandi | |
| Slatted | |
| Machined8 | 1 |
| Machined200 | 1 |
| Value | Count | Frequency (%) | |
| Machined | 42 | 7.9% | |
| Leylandi | 15 | 2.8% | |
| Slatted | 5 | 0.9% | |
| Machined8 | 1 | 0.2% | |
| Machined200 | 1 | 0.2% | |
| (Missing) | 466 | 87.9% |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 3.1% |
Length
| Max length | 11 |
|---|---|
| Median length | 3 |
| Mean length | 3.601886792 |
| Min length | 3 |
| Distinct | 5 |
|---|---|
| Distinct (%) | 55.6% |
| Missing | 521 |
| Missing (%) | 98.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.622222222 |
|---|---|
| Minimum | 0.6 |
| Maximum | 2.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 0.6 |
|---|---|
| 5-th percentile | 0.76 |
| Q1 | 1.5 |
| median | 1.5 |
| Q3 | 2 |
| 95-th percentile | 2.3 |
| Maximum | 2.5 |
| Range | 1.9 |
| Interquartile range (IQR) | 0.5 |
Descriptive statistics
| Standard deviation | 0.5783117191 |
|---|---|
| Coefficient of variation (CV) | 0.3564935255 |
| Kurtosis | -0.02810517702 |
| Mean | 1.622222222 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | -0.395916204 |
| Sum | 14.6 |
| Variance | 0.3344444444 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2 | 3 | 0.6% | |
| 1.5 | 3 | 0.6% | |
| 0.6 | 1 | 0.2% | |
| 1 | 1 | 0.2% | |
| 2.5 | 1 | 0.2% | |
| (Missing) | 521 | 98.3% |
| Value | Count | Frequency (%) | |
| 0.6 | 1 | 0.2% | |
| 1 | 1 | 0.2% | |
| 1.5 | 3 | 0.6% | |
| 2 | 3 | 0.6% | |
| 2.5 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 2.5 | 1 | 0.2% | |
| 2 | 3 | 0.6% | |
| 1.5 | 3 | 0.6% | |
| 1 | 1 | 0.2% | |
| 0.6 | 1 | 0.2% |
| Distinct | 6 |
|---|---|
| Distinct (%) | 66.7% |
| Missing | 521 |
| Missing (%) | 98.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.355555556 |
|---|---|
| Minimum | 1 |
| Maximum | 40 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1.2 |
| median | 3 |
| Q3 | 3 |
| 95-th percentile | 36 |
| Maximum | 40 |
| Range | 39 |
| Interquartile range (IQR) | 1.8 |
Descriptive statistics
| Standard deviation | 14.77625723 |
|---|---|
| Coefficient of variation (CV) | 1.579409918 |
| Kurtosis | 1.527861048 |
| Mean | 9.355555556 |
| Median Absolute Deviation (MAD) | 1.8 |
| Skewness | 1.728529482 |
| Sum | 84.2 |
| Variance | 218.3377778 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 3 | 3 | 0.6% | |
| 1 | 2 | 0.4% | |
| 1.2 | 1 | 0.2% | |
| 40 | 1 | 0.2% | |
| 2 | 1 | 0.2% | |
| 30 | 1 | 0.2% | |
| (Missing) | 521 | 98.3% |
| Value | Count | Frequency (%) | |
| 1 | 2 | 0.4% | |
| 1.2 | 1 | 0.2% | |
| 2 | 1 | 0.2% | |
| 3 | 3 | 0.6% | |
| 30 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 40 | 1 | 0.2% | |
| 30 | 1 | 0.2% | |
| 3 | 3 | 0.6% | |
| 2 | 1 | 0.2% | |
| 1.2 | 1 | 0.2% |
| Distinct | 8 |
|---|---|
| Distinct (%) | 88.9% |
| Missing | 521 |
| Missing (%) | 98.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.81111111 |
|---|---|
| Minimum | 1 |
| Maximum | 75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 10 |
| Q3 | 35.3 |
| 95-th percentile | 67 |
| Maximum | 75 |
| Range | 74 |
| Interquartile range (IQR) | 33.3 |
Descriptive statistics
| Standard deviation | 27.13293407 |
|---|---|
| Coefficient of variation (CV) | 1.243995958 |
| Kurtosis | 0.3152610357 |
| Mean | 21.81111111 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 1.257874818 |
| Sum | 196.3 |
| Variance | 736.1961111 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 2 | 0.4% | |
| 35.3 | 1 | 0.2% | |
| 75 | 1 | 0.2% | |
| 10 | 1 | 0.2% | |
| 5 | 1 | 0.2% | |
| 2 | 1 | 0.2% | |
| 55 | 1 | 0.2% | |
| 12 | 1 | 0.2% | |
| (Missing) | 521 | 98.3% |
| Value | Count | Frequency (%) | |
| 1 | 2 | 0.4% | |
| 2 | 1 | 0.2% | |
| 5 | 1 | 0.2% | |
| 10 | 1 | 0.2% | |
| 12 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 75 | 1 | 0.2% | |
| 55 | 1 | 0.2% | |
| 35.3 | 1 | 0.2% | |
| 12 | 1 | 0.2% | |
| 10 | 1 | 0.2% |
| Distinct | 1 |
|---|---|
| Distinct (%) | 7.1% |
| Missing | 516 |
| Missing (%) | 97.4% |
| Memory size | 4.1 KiB |
| clay |
|---|
| Value | Count | Frequency (%) | |
| clay | 14 | 2.6% | |
| (Missing) | 516 | 97.4% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.026415094 |
| Min length | 3 |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 102 |
| Missing (%) | 19.2% |
| Memory size | 4.1 KiB |
| moderate | |
|---|---|
| high | |
| low | 25 |
| Value | Count | Frequency (%) | |
| moderate | 325 | 61.3% | |
| high | 78 | 14.7% | |
| low | 25 | 4.7% | |
| (Missing) | 102 | 19.2% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 6.213207547 |
| Min length | 3 |
FR3 Area Units
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 1 |
| Missing (%) | 0.2% |
| Memory size | 4.1 KiB |
| ha | |
|---|---|
| m2 | 2 |
| Value | Count | Frequency (%) | |
| ha | 527 | 99.4% | |
| m2 | 2 | 0.4% | |
| (Missing) | 1 | 0.2% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.001886792 |
| Min length | 2 |
| Distinct | 8 |
|---|---|
| Distinct (%) | 66.7% |
| Missing | 518 |
| Missing (%) | 97.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 42.39166667 |
|---|---|
| Minimum | 0 |
| Maximum | 500 |
| Zeros | 4 |
| Zeros (%) | 0.8% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.15 |
| Q3 | 1.625 |
| 95-th percentile | 227.09 |
| Maximum | 500 |
| Range | 500 |
| Interquartile range (IQR) | 1.625 |
Descriptive statistics
| Standard deviation | 144.1139414 |
|---|---|
| Coefficient of variation (CV) | 3.399581869 |
| Kurtosis | 11.99796784 |
| Mean | 42.39166667 |
| Median Absolute Deviation (MAD) | 0.15 |
| Skewness | 3.463696761 |
| Sum | 508.7 |
| Variance | 20768.82811 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 4 | 0.8% | |
| 0.1 | 2 | 0.4% | |
| 0.2 | 1 | 0.2% | |
| 3.8 | 1 | 0.2% | |
| 500 | 1 | 0.2% | |
| 2 | 1 | 0.2% | |
| 1.5 | 1 | 0.2% | |
| 1 | 1 | 0.2% | |
| (Missing) | 518 | 97.7% |
| Value | Count | Frequency (%) | |
| 0 | 4 | 0.8% | |
| 0.1 | 2 | 0.4% | |
| 0.2 | 1 | 0.2% | |
| 1 | 1 | 0.2% | |
| 1.5 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 500 | 1 | 0.2% | |
| 3.8 | 1 | 0.2% | |
| 2 | 1 | 0.2% | |
| 1.5 | 1 | 0.2% | |
| 1 | 1 | 0.2% |
| Distinct | 56 |
|---|---|
| Distinct (%) | 10.7% |
| Missing | 8 |
| Missing (%) | 1.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 134.0804598 |
|---|---|
| Minimum | 0 |
| Maximum | 8000 |
| Zeros | 3 |
| Zeros (%) | 0.6% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 15 |
| Q1 | 25 |
| median | 40 |
| Q3 | 87.5 |
| 95-th percentile | 438 |
| Maximum | 8000 |
| Range | 8000 |
| Interquartile range (IQR) | 62.5 |
Descriptive statistics
| Standard deviation | 472.5971503 |
|---|---|
| Coefficient of variation (CV) | 3.524727996 |
| Kurtosis | 160.2210438 |
| Mean | 134.0804598 |
| Median Absolute Deviation (MAD) | 20 |
| Skewness | 11.10319328 |
| Sum | 69990 |
| Variance | 223348.0665 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 25 | 66 | 12.5% | |
| 30 | 62 | 11.7% | |
| 20 | 48 | 9.1% | |
| 100 | 45 | 8.5% | |
| 40 | 42 | 7.9% | |
| 50 | 39 | 7.4% | |
| 60 | 31 | 5.8% | |
| 150 | 25 | 4.7% | |
| 15 | 25 | 4.7% | |
| 75 | 17 | 3.2% | |
| Other values (46) | 122 | 23.0% |
| Value | Count | Frequency (%) | |
| 0 | 3 | 0.6% | |
| 5 | 1 | 0.2% | |
| 10 | 10 | 1.9% | |
| 15 | 25 | 4.7% | |
| 20 | 48 | 9.1% |
| Value | Count | Frequency (%) | |
| 8000 | 1 | 0.2% | |
| 4154 | 1 | 0.2% | |
| 2344 | 1 | 0.2% | |
| 2250 | 1 | 0.2% | |
| 2100 | 2 | 0.4% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 28.6% |
| Missing | 523 |
| Missing (%) | 98.7% |
| Memory size | 4.1 KiB |
| 0 | |
|---|---|
| 5 |
| Value | Count | Frequency (%) | |
| 0 | 6 | 1.1% | |
| 5 | 1 | 0.2% | |
| (Missing) | 523 | 98.7% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 14.3% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 138 |
| Missing (%) | 26.0% |
| Memory size | 4.1 KiB |
| no | |
|---|---|
| yes | 19 |
| (Missing) |
| Value | Count | Frequency (%) | |
| no | 373 | 70.4% | |
| yes | 19 | 3.6% | |
| (Missing) | 138 | 26.0% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 381 |
| Missing (%) | 71.9% |
| Memory size | 4.1 KiB |
| yes | |
|---|---|
| no | |
| (Missing) |
| Value | Count | Frequency (%) | |
| yes | 85 | 16.0% | |
| no | 64 | 12.1% | |
| (Missing) | 381 | 71.9% |
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 33 |
| Missing (%) | 6.2% |
| Memory size | 4.1 KiB |
| good | |
|---|---|
| moderate | |
| absent | 11 |
| poor | 9 |
| Value | Count | Frequency (%) | |
| good | 426 | 80.4% | |
| moderate | 51 | 9.6% | |
| absent | 11 | 2.1% | |
| poor | 9 | 1.7% | |
| (Missing) | 33 | 6.2% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 8 |
|---|---|
| Median length | 4 |
| Mean length | 4.364150943 |
| Min length | 3 |
| Distinct | 97 |
|---|---|
| Distinct (%) | 19.5% |
| Missing | 32 |
| Missing (%) | 6.0% |
| Memory size | 4.1 KiB |
| Minimum | 2018-05-31 12:00:00 |
|---|---|
| Maximum | 2020-10-07 11:00:00 |
| Distinct | 177 |
|---|---|
| Distinct (%) | 55.5% |
| Missing | 211 |
| Missing (%) | 39.8% |
| Memory size | 4.1 KiB |
| Slatted | |
|---|---|
| Healey | 13 |
| Not finished | 12 |
| Leaky Barrier | 12 |
| Slatted Dam | 10 |
| Other values (172) |
| Value | Count | Frequency (%) | |
| Slatted | 61 | 11.5% | |
| Healey | 13 | 2.5% | |
| Not finished | 12 | 2.3% | |
| Leaky Barrier | 12 | 2.3% | |
| Slatted Dam | 10 | 1.9% | |
| Clear brash | 7 | 1.3% | |
| Leaky barrier | 6 | 1.1% | |
| Needs Banding | 5 | 0.9% | |
| Slatted Dam | 5 | 0.9% | |
| Vale | 4 | 0.8% | |
| Other values (167) | 184 | 34.7% | |
| (Missing) | 211 | 39.8% |
Unique
| Unique | 154 ? |
|---|---|
| Unique (%) | 48.3% |
Length
| Max length | 112 |
|---|---|
| Median length | 7 |
| Mean length | 12.22264151 |
| Min length | 3 |
| Distinct | 530 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 KiB |
| Minimum | 2019-08-03 18:37:53 |
|---|---|
| Maximum | 2020-10-07 15:13:58 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 491 |
| Missing (%) | 92.6% |
| Memory size | 4.1 KiB |
| gsmithadmin |
|---|
| Value | Count | Frequency (%) | |
| gsmithadmin | 39 | 7.4% | |
| (Missing) | 491 | 92.6% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 11 |
|---|---|
| Median length | 3 |
| Mean length | 3.588679245 |
| Min length | 3 |
EditDate
Date
| Distinct | 529 |
|---|---|
| Distinct (%) | 99.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 KiB |
| Minimum | 2020-01-23 19:44:47 |
|---|---|
| Maximum | 2020-10-15 08:50:40 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 12 |
| Missing (%) | 2.3% |
| Memory size | 4.1 KiB |
| gsmithadmin |
|---|
| Value | Count | Frequency (%) | |
| gsmithadmin | 518 | 97.7% | |
| (Missing) | 12 | 2.3% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.81886792 |
| Min length | 3 |
| Distinct | 528 |
|---|---|
| Distinct (%) | 99.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -1.631711497 |
|---|---|
| Minimum | -1.81663 |
| Maximum | -1.484981474 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | -1.81663 |
|---|---|
| 5-th percentile | -1.769682917 |
| Q1 | -1.709705417 |
| median | -1.641680582 |
| Q3 | -1.542998485 |
| 95-th percentile | -1.499103574 |
| Maximum | -1.484981474 |
| Range | 0.3316485259 |
| Interquartile range (IQR) | 0.1667069318 |
Descriptive statistics
| Standard deviation | 0.09211958168 |
|---|---|
| Coefficient of variation (CV) | -0.05645580231 |
| Kurtosis | -1.321759833 |
| Mean | -1.631711497 |
| Median Absolute Deviation (MAD) | 0.08304808244 |
| Skewness | -0.08702664033 |
| Sum | -864.8070932 |
| Variance | 0.008486017329 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| -1.577993333 | 2 | 0.4% | |
| -1.70211 | 2 | 0.4% | |
| -1.499401765 | 1 | 0.2% | |
| -1.756139783 | 1 | 0.2% | |
| -1.577623333 | 1 | 0.2% | |
| -1.769746667 | 1 | 0.2% | |
| -1.701323417 | 1 | 0.2% | |
| -1.756386452 | 1 | 0.2% | |
| -1.6694414 | 1 | 0.2% | |
| -1.526229819 | 1 | 0.2% | |
| Other values (518) | 518 | 97.7% |
| Value | Count | Frequency (%) | |
| -1.81663 | 1 | 0.2% | |
| -1.81656 | 1 | 0.2% | |
| -1.81053 | 1 | 0.2% | |
| -1.79983 | 1 | 0.2% | |
| -1.783210321 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| -1.484981474 | 1 | 0.2% | |
| -1.485242882 | 1 | 0.2% | |
| -1.485404502 | 1 | 0.2% | |
| -1.485655783 | 1 | 0.2% | |
| -1.485774476 | 1 | 0.2% |
latitude
Real number (ℝ≥0)
| Distinct | 526 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52.03504679 |
|---|---|
| Minimum | 51.97943431 |
| Maximum | 52.07702522 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 51.97943431 |
|---|---|
| 5-th percentile | 51.99026192 |
| Q1 | 52.02048027 |
| median | 52.03628758 |
| Q3 | 52.05212133 |
| 95-th percentile | 52.07092871 |
| Maximum | 52.07702522 |
| Range | 0.09759090455 |
| Interquartile range (IQR) | 0.03164105907 |
Descriptive statistics
| Standard deviation | 0.02390600746 |
|---|---|
| Coefficient of variation (CV) | 0.0004594212735 |
| Kurtosis | -0.4130484614 |
| Mean | 52.03504679 |
| Median Absolute Deviation (MAD) | 0.0158276673 |
| Skewness | -0.4723106848 |
| Sum | 27578.5748 |
| Variance | 0.0005714971927 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 51.99028333 | 3 | 0.6% | |
| 51.98011 | 2 | 0.4% | |
| 51.99023167 | 2 | 0.4% | |
| 52.05078223 | 1 | 0.2% | |
| 52.01738375 | 1 | 0.2% | |
| 52.03630063 | 1 | 0.2% | |
| 52.029972 | 1 | 0.2% | |
| 52.05561628 | 1 | 0.2% | |
| 52.035833 | 1 | 0.2% | |
| 52.0406 | 1 | 0.2% | |
| Other values (516) | 516 | 97.4% |
| Value | Count | Frequency (%) | |
| 51.97943431 | 1 | 0.2% | |
| 51.97954167 | 1 | 0.2% | |
| 51.97978667 | 1 | 0.2% | |
| 51.98002833 | 1 | 0.2% | |
| 51.98011 | 2 | 0.4% |
| Value | Count | Frequency (%) | |
| 52.07702522 | 1 | 0.2% | |
| 52.07656807 | 1 | 0.2% | |
| 52.0763655 | 1 | 0.2% | |
| 52.07602425 | 1 | 0.2% | |
| 52.07577705 | 1 | 0.2% |
log10_price
Real number (ℝ)
| Distinct | 38 |
|---|---|
| Distinct (%) | 7.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.572885388 |
|---|---|
| Minimum | -2 |
| Maximum | 3.778151974 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | -2 |
|---|---|
| 5-th percentile | 0.004321373783 |
| Q1 | 0.3031960574 |
| median | 2.000043427 |
| Q3 | 2.176120211 |
| 95-th percentile | 2.829869242 |
| Maximum | 3.778151974 |
| Range | 5.778151974 |
| Interquartile range (IQR) | 1.872924154 |
Descriptive statistics
| Standard deviation | 1.071204284 |
|---|---|
| Coefficient of variation (CV) | 0.6810440816 |
| Kurtosis | 0.5523428699 |
| Mean | 1.572885388 |
| Median Absolute Deviation (MAD) | 0.1760767838 |
| Skewness | -1.036673032 |
| Sum | 833.6292555 |
| Variance | 1.147478619 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2.176120211 | 119 | 22.5% | |
| 2.000043427 | 115 | 21.7% | |
| 0.004321373783 | 102 | 19.2% | |
| 0.3031960574 | 34 | 6.4% | |
| 2.079217436 | 28 | 5.3% | |
| 1.954290762 | 23 | 4.3% | |
| 2.100405012 | 15 | 2.8% | |
| 2.255296632 | 14 | 2.6% | |
| 1.778223627 | 10 | 1.9% | |
| -2 | 9 | 1.7% | |
| Other values (28) | 61 | 11.5% |
| Value | Count | Frequency (%) | |
| -2 | 9 | 1.7% | |
| 0.004321373783 | 102 | 19.2% | |
| 0.3031960574 | 34 | 6.4% | |
| 1.278982117 | 1 | 0.2% | |
| 1.778223627 | 10 | 1.9% |
| Value | Count | Frequency (%) | |
| 3.778151974 | 1 | 0.2% | |
| 3.690196966 | 1 | 0.2% | |
| 3.610661228 | 1 | 0.2% | |
| 3.602061077 | 1 | 0.2% | |
| 3.579784739 | 1 | 0.2% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| ObjectID | GlobalID | Select project | FR1_ProjectName | Asset ID: | Asset Type | Asset Description | Date Installed | Installed Cost (£) | Watercourse Type | Stream Width (m) | Land Drainage Consent Difficulty | Ecological Consent Difficulty | Average member length in Leaky Barrier (m) | Wood Diameter (cm) | Height of Leaky Barrier above bed (cm) | Height of Leaky Barrier above bank (cm) | Wood Species Used | Other Wood Species | Bund height (m) | Bund width (m) | Bund length (m) | Bund Material | Gully Block Length (m) | Gully Block Width (m) | Gully Block Material | Soil Equipment or Technique Used | Flood Efficacy | FR3 Area Units | FR3_AreaRough | Storage Created (m3) | FR3_AreaIncreasedLoss | Changed Flood Pathway? | Reduced Erosion? | Asset Condition | Date Assessed | Comments | CreationDate | Creator | EditDate | Editor | longitude | latitude | log10_price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 883 | 33059012-1c4d-43c7-adb7-496972f3c9b4 | A017 | Shipston | A017_2006151117 | leaky_barriers | 9 | 2020-06-02 11:00:00 | 1 | ordinary | 3.0 | easy | n_a | 5.0 | 20.0 | 30.0 | 0.0 | willow_dead | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 135.0 | NaN | no | NaN | good | 2020-06-15 11:00:00 | NaN | 2020-06-15 10:18:01 | gsmithadmin | 2020-08-03 11:44:52 | NaN | -1.715078 | 52.069716 | 0.004321 |
| 1 | 1066 | 02b90a36-d984-4b36-a299-4fbbe884f7b2 | A017 | Shipston | A017_2008051630 | leaky_barriers | BLOCKPOTT*1 | 2020-08-05 11:00:00 | 260 | ordinary | 1.5 | easy | n_a | 3.0 | NaN | 15.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 40.0 | NaN | no | NaN | good | 2020-06-29 23:00:00 | Slatted | 2020-08-05 16:44:24 | NaN | 2020-09-18 19:01:54 | gsmithadmin | -1.732871 | 52.026232 | 2.414990 |
| 2 | 1067 | 6f0e9956-8d95-4ebf-a540-9f0cabc735e9 | A017 | Shipston | A017_2008051627 | leaky_barriers | BLOCKPOTT*2 | 2020-08-05 11:00:00 | 260 | ordinary | 1.5 | easy | n_a | 3.5 | NaN | 15.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 30.0 | NaN | no | NaN | good | 2020-06-29 23:00:00 | Slatted | 2020-08-05 16:44:36 | NaN | 2020-09-18 19:02:03 | gsmithadmin | -1.732574 | 52.026312 | 2.414990 |
| 3 | 1068 | a5d7435c-363e-41bf-ac2e-cea617acbfcd | A017 | Shipston | A017_2008051625 | leaky_barriers | BLOCKPOTT*3 | 2020-08-05 11:00:00 | 260 | ordinary | 1.5 | easy | n_a | 3.0 | NaN | 15.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 25.0 | NaN | no | NaN | good | 2020-06-29 23:00:00 | Slatted | 2020-08-05 16:44:49 | NaN | 2020-09-18 19:02:11 | gsmithadmin | -1.732450 | 52.026399 | 2.414990 |
| 4 | 1069 | 01f0b340-5a4d-483d-91d0-7161b87d3ccb | A017 | Shipston | A017_2008051622 | leaky_barriers | BLOCKPOTT*4 | 2020-08-05 11:00:00 | 260 | ordinary | 2.0 | easy | n_a | 4.0 | NaN | 15.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 30.0 | NaN | no | NaN | good | 2020-06-29 23:00:00 | Slatted | 2020-08-05 16:45:02 | NaN | 2020-09-18 19:02:50 | gsmithadmin | -1.732442 | 52.026492 | 2.414990 |
| 5 | 1058 | 7b72fa58-62c9-4c1c-9617-a3fb8bf7cd83 | A017 | Shipston | A017_2008051617 | leaky_barriers | BLOCKPOTT*5 | 2020-08-05 11:00:00 | 260 | ordinary | 1.0 | easy | n_a | 3.0 | NaN | 15.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ha | NaN | 25.0 | NaN | no | NaN | good | 2020-06-29 23:00:00 | Slatted | 2020-08-05 15:22:21 | NaN | 2020-09-18 19:02:22 | gsmithadmin | -1.732281 | 52.026592 | 2.414990 |
| 6 | 442 | 1d32eb4f-29cb-4dd9-8e9c-4d94d643dc02 | A017 | Shipston | A017_2002241950 | leaky_barriers | BLOCKPOTT01LB1 | 2017-10-10 12:00:00 | 60 | ordinary | 1.0 | easy | n_a | 2.5 | 10.0 | 5.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | low | ha | NaN | 10.0 | NaN | no | NaN | moderate | 2020-02-15 12:00:00 | Low priority | 2020-02-24 20:06:31 | gsmithadmin | 2020-02-28 07:24:22 | gsmithadmin | -1.731846 | 52.022910 | 1.778224 |
| 7 | 443 | 06539413-6f5b-4643-8dca-6e8940039a05 | A017 | Shipston | A017_2002242006 | leaky_barriers | BLOCKPOTT02LB2 | 2017-10-10 12:00:00 | 60 | ordinary | 1.0 | easy | n_a | 2.0 | 10.0 | 15.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | low | ha | NaN | 10.0 | NaN | NaN | NaN | moderate | 2020-02-15 12:00:00 | Silted, some scouring. Low Priority | 2020-02-24 20:13:57 | gsmithadmin | 2020-02-28 07:24:32 | gsmithadmin | -1.731913 | 52.023080 | 1.778224 |
| 8 | 444 | 2e6b604a-fca5-44f1-85e1-118e97dd4afd | A017 | Shipston | A017_2002242017 | leaky_barriers | BLOCKPOTT03LB3 | 2017-10-10 12:00:00 | 60 | ordinary | 1.5 | easy | n_a | 2.5 | 15.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | low | ha | NaN | 10.0 | NaN | no | NaN | moderate | 2020-02-15 12:00:00 | Silted. Low priority | 2020-02-24 20:21:28 | gsmithadmin | 2020-02-28 07:24:41 | gsmithadmin | -1.731838 | 52.023261 | 1.778224 |
| 9 | 445 | 3824078b-cb41-40f2-8e84-469b90340bcb | A017 | Shipston | A017_2002242021 | leaky_barriers | BLOCKPOTT04LB4 | 2017-10-10 12:00:00 | 60 | ordinary | NaN | easy | n_a | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | low | ha | NaN | 10.0 | NaN | no | NaN | moderate | 2020-02-15 12:00:00 | Badly silted. Low priority | 2020-02-24 20:25:54 | gsmithadmin | 2020-02-28 07:24:51 | gsmithadmin | -1.731857 | 52.023405 | 1.778224 |
Last rows
| ObjectID | GlobalID | Select project | FR1_ProjectName | Asset ID: | Asset Type | Asset Description | Date Installed | Installed Cost (£) | Watercourse Type | Stream Width (m) | Land Drainage Consent Difficulty | Ecological Consent Difficulty | Average member length in Leaky Barrier (m) | Wood Diameter (cm) | Height of Leaky Barrier above bed (cm) | Height of Leaky Barrier above bank (cm) | Wood Species Used | Other Wood Species | Bund height (m) | Bund width (m) | Bund length (m) | Bund Material | Gully Block Length (m) | Gully Block Width (m) | Gully Block Material | Soil Equipment or Technique Used | Flood Efficacy | FR3 Area Units | FR3_AreaRough | Storage Created (m3) | FR3_AreaIncreasedLoss | Changed Flood Pathway? | Reduced Erosion? | Asset Condition | Date Assessed | Comments | CreationDate | Creator | EditDate | Editor | longitude | latitude | log10_price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 520 | 1003 | 0e4e6703-8d5e-4d6c-af5e-7e68182a9ac1 | A017 | Shipston | A017_2007161459 | leaky_barriers | SUTTWALT13LB12 | 2020-06-01 11:00:00 | 150 | ordinary | 1.0 | easy | n_a | 2.5 | 20.0 | 20.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 25.0 | NaN | no | NaN | good | 2020-07-15 23:00:00 | Leaky Barrier | 2020-07-16 16:18:47 | NaN | 2020-07-20 19:22:18 | gsmithadmin | -1.527595 | 52.055507 | 2.176120 |
| 521 | 1002 | a6eff560-2b31-4a28-b5a3-1513759fef80 | A017 | Shipston | A017_2007161502 | leaky_barriers | SUTTWALT14LB13 | 2020-06-01 11:00:00 | 150 | ordinary | 1.0 | easy | n_a | 2.0 | 12.0 | 15.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 20.0 | NaN | no | NaN | good | 2020-07-15 23:00:00 | Leaky barrier | 2020-07-16 16:18:40 | NaN | 2020-07-20 19:31:42 | gsmithadmin | -1.527752 | 52.055525 | 2.176120 |
| 522 | 1001 | a03ead20-210b-4fe8-ae6c-7d0039e410d1 | A017 | Shipston | A017_2007161505 | leaky_barriers | SUTTWALT15LB14 | 2020-06-01 11:00:00 | 150 | ordinary | 1.0 | easy | n_a | 2.0 | 20.0 | 30.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 20.0 | NaN | no | NaN | good | 2020-07-15 23:00:00 | Leaky Barrier | 2020-07-16 16:18:33 | NaN | 2020-07-20 19:31:31 | gsmithadmin | -1.528081 | 52.055561 | 2.176120 |
| 523 | 1000 | 9396b320-6d61-44cb-aaf6-a041de0e2cf0 | A017 | Shipston | A017_2007161508 | leaky_barriers | SUTTWALT16LB15 | 2020-06-01 11:00:00 | 150 | ordinary | 1.5 | easy | n_a | 3.0 | 15.0 | 25.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 15.0 | NaN | no | NaN | good | 2020-07-15 23:00:00 | Leaky barrier | 2020-07-16 16:18:26 | NaN | 2020-07-20 19:31:05 | gsmithadmin | -1.528225 | 52.055615 | 2.176120 |
| 524 | 999 | 33dd10d5-ad0b-415d-ac97-b0639f88bedd | A017 | Shipston | A017_2007161511 | leaky_barriers | SUTTWALT17LB16 | 2020-06-01 11:00:00 | 150 | ordinary | 1.0 | easy | n_a | 2.0 | 20.0 | 20.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 15.0 | NaN | no | NaN | good | 2020-07-15 23:00:00 | Leaky Barrier | 2020-07-16 16:18:18 | NaN | 2020-07-20 19:34:33 | gsmithadmin | -1.528436 | 52.055616 | 2.176120 |
| 525 | 998 | 0171abab-a48d-4d82-a873-740b8160b978 | A017 | Shipston | A017_2007161517 | leaky_barriers | SUTTWALT18LB17 | 2020-07-16 11:00:00 | 150 | ordinary | 1.0 | easy | n_a | 2.0 | 15.0 | 15.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 15.0 | NaN | no | NaN | good | 2020-07-15 23:00:00 | Leaky Barrier | 2020-07-16 16:18:12 | NaN | 2020-07-20 19:36:26 | gsmithadmin | -1.528679 | 52.055711 | 2.176120 |
| 526 | 997 | b4c83c49-7077-415a-9693-9560b522dac5 | A017 | Shipston | A017_2007161520 | leaky_barriers | SUTTWALT19LB18 | 2020-07-16 11:00:00 | 150 | ordinary | 1.5 | easy | n_a | 2.5 | 15.0 | 15.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 20.0 | NaN | no | NaN | good | 2020-07-15 23:00:00 | Leaky Barrier | 2020-07-16 16:18:05 | NaN | 2020-07-20 19:38:59 | gsmithadmin | -1.528809 | 52.055872 | 2.176120 |
| 527 | 996 | daf06754-06c8-4a34-a25d-99bb95c352c4 | A017 | Shipston | A017_2007161523 | leaky_barriers | SUTTWALT20LB19 | 2020-07-16 11:00:00 | 1 | ordinary | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ha | NaN | 20.0 | NaN | NaN | NaN | good | NaT | Leaky Barrier | 2020-07-16 16:17:58 | NaN | 2020-09-03 20:42:20 | gsmithadmin | -1.529007 | 52.055993 | 0.004321 |
| 528 | 995 | c560682c-3e19-4a58-9505-935067403815 | A017 | Shipston | A017_2007161526 | leaky_barriers | SUTTWALT21LB20 | 2020-06-01 11:00:00 | 150 | ordinary | 1.5 | easy | n_a | 2.5 | 15.0 | 20.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 20.0 | NaN | no | NaN | good | 2020-07-15 23:00:00 | Leaky Barrier | 2020-07-16 16:17:49 | NaN | 2020-07-20 19:42:36 | gsmithadmin | -1.529026 | 52.056142 | 2.176120 |
| 529 | 994 | 76e4cf1b-14bf-415a-a918-048b221e8462 | A017 | Shipston | A017_2007161530 | leaky_barriers | SUTTWALT22LB21 | 2020-06-01 11:00:00 | 150 | ordinary | 1.5 | easy | n_a | 2.5 | 20.0 | 20.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 20.0 | NaN | no | NaN | good | 2020-07-15 23:00:00 | Leaky Barrier | 2020-07-16 16:17:42 | NaN | 2020-07-20 19:45:17 | gsmithadmin | -1.529134 | 52.056240 | 2.176120 |